Dataset statistics
| Number of variables | 36 |
|---|---|
| Number of observations | 135038 |
| Missing cells | 293365 |
| Missing cells (%) | 6.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 37.1 MiB |
| Average record size in memory | 288.0 B |
Variable types
| Numeric | 23 |
|---|---|
| Categorical | 13 |
Product_type has constant value "FRM" | Constant |
Seller_Name has a high cardinality: 94 distinct values | High cardinality |
Property_state has a high cardinality: 54 distinct values | High cardinality |
Origination_Date has a high cardinality: 234 distinct values | High cardinality |
First_payment_date has a high cardinality: 235 distinct values | High cardinality |
Qdate has a high cardinality: 78 distinct values | High cardinality |
Original_Interest_Rate is highly correlated with CPIAUCSL and 4 other fields | High correlation |
Original_LTV_(OLTV) is highly correlated with Original_Combined_LTV_(CLTV) and 1 other fields | High correlation |
Original_Combined_LTV_(CLTV) is highly correlated with Original_LTV_(OLTV) and 1 other fields | High correlation |
Borrower_Credit_Score_at_Origination is highly correlated with Co-borrower_credit_score_at_origination | High correlation |
Primary_mortgage_insurance_percent is highly correlated with Original_LTV_(OLTV) and 1 other fields | High correlation |
Co-borrower_credit_score_at_origination is highly correlated with Borrower_Credit_Score_at_Origination | High correlation |
UNRATE is highly correlated with DEXUSEU | High correlation |
CPIAUCSL is highly correlated with Original_Interest_Rate and 7 other fields | High correlation |
TCMR is highly correlated with Original_Interest_Rate and 4 other fields | High correlation |
POILWTIUSDM is highly correlated with Original_Interest_Rate and 7 other fields | High correlation |
TTLCONS is highly correlated with CPIAUCSL and 2 other fields | High correlation |
DEXUSEU is highly correlated with UNRATE and 3 other fields | High correlation |
BOPGSTB is highly correlated with POILWTIUSDM and 2 other fields | High correlation |
GOLDAMGBD228NLBM is highly correlated with Original_Interest_Rate and 6 other fields | High correlation |
CSUSHPISA is highly correlated with CPIAUCSL and 5 other fields | High correlation |
MSPUS is highly correlated with Original_Interest_Rate and 7 other fields | High correlation |
Original_Interest_Rate is highly correlated with CPIAUCSL and 4 other fields | High correlation |
Original_LTV_(OLTV) is highly correlated with Original_Combined_LTV_(CLTV) and 1 other fields | High correlation |
Original_Combined_LTV_(CLTV) is highly correlated with Original_LTV_(OLTV) and 1 other fields | High correlation |
Borrower_Credit_Score_at_Origination is highly correlated with Co-borrower_credit_score_at_origination | High correlation |
Primary_mortgage_insurance_percent is highly correlated with Original_LTV_(OLTV) and 1 other fields | High correlation |
Co-borrower_credit_score_at_origination is highly correlated with Borrower_Credit_Score_at_Origination | High correlation |
UNRATE is highly correlated with TTLCONS and 1 other fields | High correlation |
CPIAUCSL is highly correlated with Original_Interest_Rate and 7 other fields | High correlation |
TCMR is highly correlated with Original_Interest_Rate and 5 other fields | High correlation |
POILWTIUSDM is highly correlated with CPIAUCSL and 3 other fields | High correlation |
TTLCONS is highly correlated with UNRATE and 4 other fields | High correlation |
DEXUSEU is highly correlated with UNRATE and 4 other fields | High correlation |
BOPGSTB is highly correlated with TTLCONS and 2 other fields | High correlation |
GOLDAMGBD228NLBM is highly correlated with Original_Interest_Rate and 6 other fields | High correlation |
CSUSHPISA is highly correlated with Original_Interest_Rate and 6 other fields | High correlation |
MSPUS is highly correlated with Original_Interest_Rate and 5 other fields | High correlation |
Original_Interest_Rate is highly correlated with CPIAUCSL and 3 other fields | High correlation |
Original_LTV_(OLTV) is highly correlated with Original_Combined_LTV_(CLTV) and 1 other fields | High correlation |
Original_Combined_LTV_(CLTV) is highly correlated with Original_LTV_(OLTV) and 1 other fields | High correlation |
Borrower_Credit_Score_at_Origination is highly correlated with Co-borrower_credit_score_at_origination | High correlation |
Primary_mortgage_insurance_percent is highly correlated with Original_LTV_(OLTV) and 1 other fields | High correlation |
Co-borrower_credit_score_at_origination is highly correlated with Borrower_Credit_Score_at_Origination | High correlation |
CPIAUCSL is highly correlated with Original_Interest_Rate and 5 other fields | High correlation |
TCMR is highly correlated with Original_Interest_Rate and 3 other fields | High correlation |
POILWTIUSDM is highly correlated with CPIAUCSL and 2 other fields | High correlation |
TTLCONS is highly correlated with CSUSHPISA and 1 other fields | High correlation |
DEXUSEU is highly correlated with POILWTIUSDM and 1 other fields | High correlation |
GOLDAMGBD228NLBM is highly correlated with Original_Interest_Rate and 5 other fields | High correlation |
CSUSHPISA is highly correlated with CPIAUCSL and 2 other fields | High correlation |
MSPUS is highly correlated with Original_Interest_Rate and 5 other fields | High correlation |
Product_type is highly correlated with Property_state and 9 other fields | High correlation |
Property_state is highly correlated with Product_type | High correlation |
Qdate is highly correlated with Product_type | High correlation |
Origination_Channel is highly correlated with Product_type | High correlation |
Number_of_units is highly correlated with Product_type | High correlation |
Property_type is highly correlated with Product_type | High correlation |
Seller_Name is highly correlated with Product_type | High correlation |
Loan_purpose is highly correlated with Product_type | High correlation |
Occupancy_type is highly correlated with Product_type | High correlation |
First_time_home_buyer_indicator is highly correlated with Product_type | High correlation |
Mortgage_Insurance_type is highly correlated with Product_type | High correlation |
Origination_Channel is highly correlated with Seller_Name | High correlation |
Seller_Name is highly correlated with Origination_Channel and 11 other fields | High correlation |
Original_Interest_Rate is highly correlated with Seller_Name and 11 other fields | High correlation |
Original_Loan_Term is highly correlated with Primary_mortgage_insurance_percent | High correlation |
Original_LTV_(OLTV) is highly correlated with Original_Combined_LTV_(CLTV) and 1 other fields | High correlation |
Original_Combined_LTV_(CLTV) is highly correlated with Original_LTV_(OLTV) and 1 other fields | High correlation |
Borrower_Credit_Score_at_Origination is highly correlated with Co-borrower_credit_score_at_origination | High correlation |
Property_state is highly correlated with Zip_code_short | High correlation |
Zip_code_short is highly correlated with Property_state | High correlation |
Primary_mortgage_insurance_percent is highly correlated with Original_Loan_Term and 2 other fields | High correlation |
Co-borrower_credit_score_at_origination is highly correlated with Borrower_Credit_Score_at_Origination | High correlation |
UNRATE is highly correlated with Seller_Name and 12 other fields | High correlation |
CPIAUCSL is highly correlated with Seller_Name and 12 other fields | High correlation |
Qdate is highly correlated with Seller_Name and 12 other fields | High correlation |
rGDP is highly correlated with UNRATE and 10 other fields | High correlation |
TCMR is highly correlated with Seller_Name and 12 other fields | High correlation |
POILWTIUSDM is highly correlated with Seller_Name and 12 other fields | High correlation |
TTLCONS is highly correlated with Seller_Name and 12 other fields | High correlation |
DEXUSEU is highly correlated with Seller_Name and 12 other fields | High correlation |
BOPGSTB is highly correlated with Original_Interest_Rate and 11 other fields | High correlation |
GOLDAMGBD228NLBM is highly correlated with Seller_Name and 12 other fields | High correlation |
CSUSHPISA is highly correlated with Seller_Name and 12 other fields | High correlation |
MSPUS is highly correlated with Seller_Name and 12 other fields | High correlation |
Original_Debt_to_Income_Ratio has 2642 (2.0%) missing values | Missing |
Primary_mortgage_insurance_percent has 110716 (82.0%) missing values | Missing |
Co-borrower_credit_score_at_origination has 67672 (50.1%) missing values | Missing |
Mortgage_Insurance_type has 110716 (82.0%) missing values | Missing |
Reproduction
| Analysis started | 2022-04-06 17:47:01.696627 |
|---|---|
| Analysis finished | 2022-04-06 17:49:02.034217 |
| Duration | 2 minutes and 0.34 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
Loan_Identifier
Real number (ℝ≥0)
| Distinct | 125363 |
|---|---|
| Distinct (%) | 92.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.518022819 × 1011 |
| Minimum | 1.00002 × 1011 |
|---|---|
| Maximum | 9.99985 × 1011 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 1.00002 × 1011 |
|---|---|
| 5-th percentile | 1.4584125 × 1011 |
| Q1 | 3.270665 × 1011 |
| median | 5.525325 × 1011 |
| Q3 | 7.7732825 × 1011 |
| 95-th percentile | 9.561356 × 1011 |
| Maximum | 9.99985 × 1011 |
| Range | 8.99983 × 1011 |
| Interquartile range (IQR) | 4.5026175 × 1011 |
Descriptive statistics
| Standard deviation | 2.597821488 × 1011 |
|---|---|
| Coefficient of variation (CV) | 0.4707884642 |
| Kurtosis | -1.201513582 |
| Mean | 5.518022819 × 1011 |
| Median Absolute Deviation (MAD) | 2.251105 × 1011 |
| Skewness | -0.008013935302 |
| Sum | 7.451427654 × 1016 |
| Variance | 6.748676485 × 1022 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.9732 × 1011 | 4 | < 0.1% |
| 2.59153 × 1011 | 4 | < 0.1% |
| 7.57067 × 1011 | 4 | < 0.1% |
| 7.50054 × 1011 | 4 | < 0.1% |
| 4.3854 × 1011 | 4 | < 0.1% |
| 6.65386 × 1011 | 4 | < 0.1% |
| 1.38101 × 1011 | 4 | < 0.1% |
| 5.37573 × 1011 | 4 | < 0.1% |
| 9.98433 × 1011 | 4 | < 0.1% |
| 3.31339 × 1011 | 4 | < 0.1% |
| Other values (125353) | 134998 |
| Value | Count | Frequency (%) |
| 1.00002 × 1011 | 1 | < 0.1% |
| 1.00032 × 1011 | 1 | < 0.1% |
| 1.00035 × 1011 | 1 | < 0.1% |
| 1.00041 × 1011 | 1 | < 0.1% |
| 1.00046 × 1011 | 1 | < 0.1% |
| 1.00049 × 1011 | 1 | < 0.1% |
| 1.00051 × 1011 | 1 | < 0.1% |
| 1.00061 × 1011 | 1 | < 0.1% |
| 1.00069 × 1011 | 1 | < 0.1% |
| 1.00072 × 1011 | 3 |
| Value | Count | Frequency (%) |
| 9.99985 × 1011 | 1 | |
| 9.99972 × 1011 | 1 | |
| 9.9997 × 1011 | 1 | |
| 9.99965 × 1011 | 1 | |
| 9.99951 × 1011 | 1 | |
| 9.9995 × 1011 | 1 | |
| 9.99949 × 1011 | 1 | |
| 9.99947 × 1011 | 1 | |
| 9.99934 × 1011 | 1 | |
| 9.99919 × 1011 | 1 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| R | |
|---|---|
| C | |
| B |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | B |
|---|---|
| 2nd row | B |
| 3rd row | B |
| 4th row | C |
| 5th row | R |
Common Values
| Value | Count | Frequency (%) |
| R | 67857 | |
| C | 46756 | |
| B | 20425 | 15.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| r | 67857 | |
| c | 46756 | |
| b | 20425 | 15.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 94 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| OTHER | |
|---|---|
| BANK OF AMERICA, N.A. | |
| WELLS FARGO BANK, N.A. | |
| JPMORGAN CHASE BANK, NA | |
| JPMORGAN CHASE BANK, NATIONAL ASSOCIATION | |
| Other values (89) |
Length
| Max length | 68 |
|---|---|
| Median length | 18 |
| Mean length | 17.40043543 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | OTHER |
|---|---|
| 2nd row | PNC BANK, N.A. |
| 3rd row | OTHER |
| 4th row | AMTRUST BANK |
| 5th row | OTHER |
Common Values
| Value | Count | Frequency (%) |
| OTHER | 46014 | |
| BANK OF AMERICA, N.A. | 15626 | 11.6% |
| WELLS FARGO BANK, N.A. | 14838 | 11.0% |
| JPMORGAN CHASE BANK, NA | 9712 | 7.2% |
| JPMORGAN CHASE BANK, NATIONAL ASSOCIATION | 7836 | 5.8% |
| CITIMORTGAGE, INC. | 5950 | 4.4% |
| GMAC MORTGAGE, LLC | 4278 | 3.2% |
| FLAGSTAR BANK, FSB | 3308 | 2.4% |
| SUNTRUST MORTGAGE INC. | 3059 | 2.3% |
| QUICKEN LOANS INC. | 3007 | 2.2% |
| Other values (84) | 21410 |
Length
| Value | Count | Frequency (%) |
| bank | 59587 | |
| other | 46014 | 12.3% |
| n.a | 31896 | 8.5% |
| chase | 17971 | 4.8% |
| jpmorgan | 17548 | 4.7% |
| of | 15977 | 4.3% |
| america | 15724 | 4.2% |
| wells | 14881 | 4.0% |
| fargo | 14881 | 4.0% |
| mortgage | 14179 | 3.8% |
| Other values (139) | 126427 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Original_Interest_Rate
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 885 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.238376478 |
| Minimum | 2.25 |
|---|---|
| Maximum | 11 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 2.25 |
|---|---|
| 5-th percentile | 3.309849915 |
| Q1 | 4.25 |
| median | 5.25 |
| Q3 | 6.125 |
| 95-th percentile | 7.375 |
| Maximum | 11 |
| Range | 8.75 |
| Interquartile range (IQR) | 1.875 |
Descriptive statistics
| Standard deviation | 1.28989546 |
|---|---|
| Coefficient of variation (CV) | 0.2462395488 |
| Kurtosis | -0.5204123179 |
| Mean | 5.238376478 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.2567090033 |
| Sum | 707379.8828 |
| Variance | 1.663830299 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5.875 | 6754 | 5.0% |
| 4.875 | 5729 | 4.2% |
| 4.375 | 4937 | 3.7% |
| 4.25 | 4926 | 3.6% |
| 5.75 | 4820 | 3.6% |
| 3.875 | 4620 | 3.4% |
| 4.5 | 4383 | 3.2% |
| 6 | 4368 | 3.2% |
| 6.25 | 4174 | 3.1% |
| 5.375 | 4146 | 3.1% |
| Other values (875) | 86181 |
| Value | Count | Frequency (%) |
| 2.25 | 4 | < 0.1% |
| 2.375 | 17 | < 0.1% |
| 2.45 | 1 | < 0.1% |
| 2.5 | 143 | |
| 2.54 | 1 | < 0.1% |
| 2.55 | 2 | < 0.1% |
| 2.5999999 | 3 | < 0.1% |
| 2.625 | 270 | |
| 2.6500001 | 1 | < 0.1% |
| 2.6600001 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 11 | 1 | < 0.1% |
| 10.25 | 2 | < 0.1% |
| 10.125 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9.875 | 1 | < 0.1% |
| 9.75 | 4 | < 0.1% |
| 9.625 | 9 | |
| 9.5 | 17 | |
| 9.375 | 13 | |
| 9.3249998 | 1 | < 0.1% |
Original_UPB
Real number (ℝ≥0)
| Distinct | 717 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 188931.0713 |
| Minimum | 8000 |
|---|---|
| Maximum | 1170000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 8000 |
|---|---|
| 5-th percentile | 59000 |
| Q1 | 108000 |
| median | 164000 |
| Q3 | 247000 |
| 95-th percentile | 405000 |
| Maximum | 1170000 |
| Range | 1162000 |
| Interquartile range (IQR) | 139000 |
Descriptive statistics
| Standard deviation | 108742.3794 |
|---|---|
| Coefficient of variation (CV) | 0.5755664151 |
| Kurtosis | 2.089248292 |
| Mean | 188931.0713 |
| Median Absolute Deviation (MAD) | 64000 |
| Skewness | 1.241016237 |
| Sum | 2.5512874 × 1010 |
| Variance | 1.182490507 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 417000 | 1986 | 1.5% |
| 100000 | 1972 | 1.5% |
| 200000 | 1714 | 1.3% |
| 150000 | 1514 | 1.1% |
| 120000 | 1263 | 0.9% |
| 160000 | 1153 | 0.9% |
| 140000 | 1108 | 0.8% |
| 180000 | 1068 | 0.8% |
| 90000 | 1064 | 0.8% |
| 80000 | 1045 | 0.8% |
| Other values (707) | 121151 |
| Value | Count | Frequency (%) |
| 8000 | 1 | < 0.1% |
| 10000 | 2 | < 0.1% |
| 11000 | 5 | |
| 13000 | 3 | < 0.1% |
| 14000 | 4 | |
| 15000 | 8 | |
| 16000 | 5 | |
| 17000 | 5 | |
| 18000 | 8 | |
| 19000 | 8 |
| Value | Count | Frequency (%) |
| 1170000 | 1 | |
| 1121000 | 1 | |
| 1000000 | 1 | |
| 985000 | 1 | |
| 938000 | 1 | |
| 927000 | 1 | |
| 870000 | 1 | |
| 815000 | 2 | |
| 813000 | 1 | |
| 805000 | 1 |
| Distinct | 127 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 307.0648262 |
| Minimum | 60 |
|---|---|
| Maximum | 360 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 60 |
|---|---|
| 5-th percentile | 180 |
| Q1 | 240 |
| median | 360 |
| Q3 | 360 |
| 95-th percentile | 360 |
| Maximum | 360 |
| Range | 300 |
| Interquartile range (IQR) | 120 |
Descriptive statistics
| Standard deviation | 82.33167429 |
|---|---|
| Coefficient of variation (CV) | 0.2681247322 |
| Kurtosis | -0.7829963816 |
| Mean | 307.0648262 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.011882662 |
| Sum | 41465420 |
| Variance | 6778.504591 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 360 | 93557 | |
| 180 | 29335 | 21.7% |
| 240 | 6223 | 4.6% |
| 120 | 3993 | 3.0% |
| 300 | 986 | 0.7% |
| 144 | 72 | 0.1% |
| 96 | 59 | < 0.1% |
| 156 | 56 | < 0.1% |
| 348 | 49 | < 0.1% |
| 168 | 49 | < 0.1% |
| Other values (117) | 659 | 0.5% |
| Value | Count | Frequency (%) |
| 60 | 4 | < 0.1% |
| 72 | 2 | < 0.1% |
| 78 | 1 | < 0.1% |
| 84 | 8 | < 0.1% |
| 96 | 59 | |
| 100 | 1 | < 0.1% |
| 103 | 1 | < 0.1% |
| 106 | 1 | < 0.1% |
| 108 | 19 | < 0.1% |
| 109 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 360 | 93557 | |
| 359 | 4 | < 0.1% |
| 358 | 4 | < 0.1% |
| 357 | 5 | < 0.1% |
| 356 | 12 | < 0.1% |
| 355 | 15 | < 0.1% |
| 354 | 27 | < 0.1% |
| 353 | 29 | < 0.1% |
| 352 | 21 | < 0.1% |
| 351 | 23 | < 0.1% |
Original_LTV_(OLTV)
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 94 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 70.05729498 |
| Minimum | 4 |
|---|---|
| Maximum | 97 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 35 |
| Q1 | 60 |
| median | 75 |
| Q3 | 80 |
| 95-th percentile | 95 |
| Maximum | 97 |
| Range | 93 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 17.4931782 |
|---|---|
| Coefficient of variation (CV) | 0.2496981679 |
| Kurtosis | 0.2871075184 |
| Mean | 70.05729498 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | -0.8332872297 |
| Sum | 9460397 |
| Variance | 306.0112836 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 80 | 27633 | |
| 95 | 8194 | 6.1% |
| 75 | 6801 | 5.0% |
| 90 | 6241 | 4.6% |
| 70 | 3848 | 2.8% |
| 79 | 3484 | 2.6% |
| 78 | 2864 | 2.1% |
| 74 | 2689 | 2.0% |
| 73 | 2525 | 1.9% |
| 77 | 2379 | 1.8% |
| Other values (84) | 68380 |
| Value | Count | Frequency (%) |
| 4 | 1 | < 0.1% |
| 5 | 4 | < 0.1% |
| 6 | 5 | < 0.1% |
| 7 | 15 | < 0.1% |
| 8 | 12 | < 0.1% |
| 9 | 22 | < 0.1% |
| 10 | 32 | |
| 11 | 41 | |
| 12 | 52 | |
| 13 | 65 |
| Value | Count | Frequency (%) |
| 97 | 1961 | 1.5% |
| 96 | 62 | < 0.1% |
| 95 | 8194 | |
| 94 | 613 | 0.5% |
| 93 | 533 | 0.4% |
| 92 | 486 | 0.4% |
| 91 | 248 | 0.2% |
| 90 | 6241 | |
| 89 | 895 | 0.7% |
| 88 | 749 | 0.6% |
Original_Combined_LTV_(CLTV)
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 110 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1031 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 70.86085801 |
| Minimum | 4 |
|---|---|
| Maximum | 142 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 36 |
| Q1 | 61 |
| median | 75 |
| Q3 | 80 |
| 95-th percentile | 95 |
| Maximum | 142 |
| Range | 138 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 17.56660673 |
|---|---|
| Coefficient of variation (CV) | 0.2479028228 |
| Kurtosis | 0.3041430708 |
| Mean | 70.86085801 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | -0.8334307875 |
| Sum | 9495851 |
| Variance | 308.585672 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 80 | 25239 | 18.7% |
| 95 | 9030 | 6.7% |
| 90 | 7567 | 5.6% |
| 75 | 6649 | 4.9% |
| 70 | 3760 | 2.8% |
| 79 | 3361 | 2.5% |
| 78 | 2776 | 2.1% |
| 74 | 2640 | 2.0% |
| 73 | 2466 | 1.8% |
| 77 | 2294 | 1.7% |
| Other values (100) | 68225 |
| Value | Count | Frequency (%) |
| 4 | 1 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 5 | < 0.1% |
| 7 | 14 | < 0.1% |
| 8 | 12 | < 0.1% |
| 9 | 21 | < 0.1% |
| 10 | 28 | |
| 11 | 36 | |
| 12 | 47 | |
| 13 | 58 |
| Value | Count | Frequency (%) |
| 142 | 1 | < 0.1% |
| 137 | 1 | < 0.1% |
| 128 | 1 | < 0.1% |
| 124 | 1 | < 0.1% |
| 111 | 1 | < 0.1% |
| 110 | 1 | < 0.1% |
| 108 | 1 | < 0.1% |
| 106 | 1 | < 0.1% |
| 105 | 38 | |
| 104 | 29 |
Number_of_Borrowers
Real number (ℝ≥0)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 31 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.587910257 |
| Minimum | 1 |
|---|---|
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.5084095479 |
|---|---|
| Coefficient of variation (CV) | 0.3201752403 |
| Kurtosis | -0.5113864406 |
| Mean | 1.587910257 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.06751714976 |
| Sum | 214379 |
| Variance | 0.2584802684 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 77876 | |
| 1 | 56485 | |
| 3 | 466 | 0.3% |
| 4 | 166 | 0.1% |
| 5 | 8 | < 0.1% |
| 6 | 4 | < 0.1% |
| 8 | 2 | < 0.1% |
| (Missing) | 31 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 56485 | |
| 2 | 77876 | |
| 3 | 466 | 0.3% |
| 4 | 166 | 0.1% |
| 5 | 8 | < 0.1% |
| 6 | 4 | < 0.1% |
| 8 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 8 | 2 | < 0.1% |
| 6 | 4 | < 0.1% |
| 5 | 8 | < 0.1% |
| 4 | 166 | 0.1% |
| 3 | 466 | 0.3% |
| 2 | 77876 | |
| 1 | 56485 |
| Distinct | 64 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2642 |
| Missing (%) | 2.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.29873259 |
| Minimum | 1 |
|---|---|
| Maximum | 64 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 25 |
| median | 33 |
| Q3 | 42 |
| 95-th percentile | 52 |
| Maximum | 64 |
| Range | 63 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 11.50869764 |
|---|---|
| Coefficient of variation (CV) | 0.3456196902 |
| Kurtosis | -0.3792129474 |
| Mean | 33.29873259 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.08045905992 |
| Sum | 4408619 |
| Variance | 132.4501214 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 44 | 4168 | 3.1% |
| 34 | 4121 | 3.1% |
| 38 | 4098 | 3.0% |
| 39 | 4096 | 3.0% |
| 36 | 4082 | 3.0% |
| 41 | 4067 | 3.0% |
| 42 | 4049 | 3.0% |
| 37 | 4046 | 3.0% |
| 31 | 4017 | 3.0% |
| 40 | 4008 | 3.0% |
| Other values (54) | 91644 |
| Value | Count | Frequency (%) |
| 1 | 11 | < 0.1% |
| 2 | 42 | < 0.1% |
| 3 | 50 | < 0.1% |
| 4 | 73 | 0.1% |
| 5 | 111 | 0.1% |
| 6 | 181 | 0.1% |
| 7 | 238 | 0.2% |
| 8 | 354 | |
| 9 | 445 | |
| 10 | 635 |
| Value | Count | Frequency (%) |
| 64 | 359 | |
| 63 | 368 | |
| 62 | 342 | |
| 61 | 423 | |
| 60 | 448 | |
| 59 | 490 | |
| 58 | 514 | |
| 57 | 543 | |
| 56 | 696 | |
| 55 | 741 |
Borrower_Credit_Score_at_Origination
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 347 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 557 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 742.4287966 |
| Minimum | 361 |
|---|---|
| Maximum | 850 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 361 |
|---|---|
| 5-th percentile | 641 |
| Q1 | 707 |
| median | 755 |
| Q3 | 786 |
| 95-th percentile | 808 |
| Maximum | 850 |
| Range | 489 |
| Interquartile range (IQR) | 79 |
Descriptive statistics
| Standard deviation | 53.42807552 |
|---|---|
| Coefficient of variation (CV) | 0.07196390517 |
| Kurtosis | 0.2222909648 |
| Mean | 742.4287966 |
| Median Absolute Deviation (MAD) | 36 |
| Skewness | -0.8345198247 |
| Sum | 99842567 |
| Variance | 2854.559254 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 791 | 1474 | 1.1% |
| 801 | 1468 | 1.1% |
| 784 | 1388 | 1.0% |
| 797 | 1381 | 1.0% |
| 802 | 1358 | 1.0% |
| 790 | 1357 | 1.0% |
| 786 | 1312 | 1.0% |
| 798 | 1300 | 1.0% |
| 788 | 1296 | 1.0% |
| 782 | 1288 | 1.0% |
| Other values (337) | 120859 |
| Value | Count | Frequency (%) |
| 361 | 1 | < 0.1% |
| 400 | 1 | < 0.1% |
| 444 | 7 | |
| 467 | 1 | < 0.1% |
| 476 | 1 | < 0.1% |
| 480 | 1 | < 0.1% |
| 488 | 1 | < 0.1% |
| 493 | 2 | < 0.1% |
| 494 | 1 | < 0.1% |
| 496 | 3 |
| Value | Count | Frequency (%) |
| 850 | 3 | < 0.1% |
| 843 | 1 | < 0.1% |
| 838 | 2 | < 0.1% |
| 837 | 2 | < 0.1% |
| 835 | 2 | < 0.1% |
| 833 | 2 | < 0.1% |
| 832 | 12 | |
| 831 | 2 | < 0.1% |
| 830 | 2 | < 0.1% |
| 829 | 18 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| P | |
|---|---|
| R | |
| C | |
| U | 50 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | P |
|---|---|
| 2nd row | P |
| 3rd row | C |
| 4th row | C |
| 5th row | C |
Common Values
| Value | Count | Frequency (%) |
| P | 47900 | |
| R | 46740 | |
| C | 40348 | |
| U | 50 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| p | 47900 | |
| r | 46740 | |
| c | 40348 | |
| u | 50 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| SF | |
|---|---|
| PU | |
| CO | |
| MH | 864 |
| CP | 673 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SF |
|---|---|
| 2nd row | SF |
| 3rd row | SF |
| 4th row | SF |
| 5th row | SF |
Common Values
| Value | Count | Frequency (%) |
| SF | 99740 | |
| PU | 23060 | 17.1% |
| CO | 10701 | 7.9% |
| MH | 864 | 0.6% |
| CP | 673 | 0.5% |
Length
Pie chart
| Value | Count | Frequency (%) |
| sf | 99740 | |
| pu | 23060 | 17.1% |
| co | 10701 | 7.9% |
| mh | 864 | 0.6% |
| cp | 673 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| 1.0 | |
|---|---|
| 2.0 | 2504 |
| 3.0 | 477 |
| 4.0 | 424 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 131633 | |
| 2.0 | 2504 | 1.9% |
| 3.0 | 477 | 0.4% |
| 4.0 | 424 | 0.3% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1.0 | 131633 | |
| 2.0 | 2504 | 1.9% |
| 3.0 | 477 | 0.4% |
| 4.0 | 424 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| P | |
|---|---|
| I | 9238 |
| S | 5401 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | P |
|---|---|
| 2nd row | P |
| 3rd row | P |
| 4th row | I |
| 5th row | P |
Common Values
| Value | Count | Frequency (%) |
| P | 120399 | |
| I | 9238 | 6.8% |
| S | 5401 | 4.0% |
Length
Pie chart
| Value | Count | Frequency (%) |
| p | 120399 | |
| i | 9238 | 6.8% |
| s | 5401 | 4.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 54 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| CA | |
|---|---|
| TX | 7990 |
| FL | 7327 |
| IL | 6468 |
| MI | 4909 |
| Other values (49) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AL |
|---|---|
| 2nd row | AL |
| 3rd row | AL |
| 4th row | AL |
| 5th row | AR |
Common Values
| Value | Count | Frequency (%) |
| CA | 20316 | 15.0% |
| TX | 7990 | 5.9% |
| FL | 7327 | 5.4% |
| IL | 6468 | 4.8% |
| MI | 4909 | 3.6% |
| NY | 4886 | 3.6% |
| WA | 4293 | 3.2% |
| PA | 4291 | 3.2% |
| MA | 4257 | 3.2% |
| NJ | 3982 | 2.9% |
| Other values (44) | 66319 |
Length
| Value | Count | Frequency (%) |
| ca | 20316 | 15.0% |
| tx | 7990 | 5.9% |
| fl | 7327 | 5.4% |
| il | 6468 | 4.8% |
| mi | 4909 | 3.6% |
| ny | 4886 | 3.6% |
| wa | 4293 | 3.2% |
| pa | 4291 | 3.2% |
| ma | 4257 | 3.2% |
| nj | 3982 | 2.9% |
| Other values (44) | 66319 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 892 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 545.9760956 |
| Minimum | 0 |
|---|---|
| Maximum | 999 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 56 |
| Q1 | 295 |
| median | 549 |
| Q3 | 844 |
| 95-th percentile | 970 |
| Maximum | 999 |
| Range | 999 |
| Interquartile range (IQR) | 549 |
Descriptive statistics
| Standard deviation | 306.0106241 |
|---|---|
| Coefficient of variation (CV) | 0.560483557 |
| Kurtosis | -1.301477705 |
| Mean | 545.9760956 |
| Median Absolute Deviation (MAD) | 268 |
| Skewness | -0.1170295055 |
| Sum | 73727520 |
| Variance | 93642.50206 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 945 | 1772 | 1.3% |
| 300 | 1194 | 0.9% |
| 600 | 1159 | 0.9% |
| 750 | 1148 | 0.9% |
| 926 | 1135 | 0.8% |
| 852 | 1099 | 0.8% |
| 980 | 1090 | 0.8% |
| 917 | 1070 | 0.8% |
| 606 | 958 | 0.7% |
| 481 | 957 | 0.7% |
| Other values (882) | 123456 |
| Value | Count | Frequency (%) |
| 0 | 3 | < 0.1% |
| 6 | 95 | |
| 7 | 117 | |
| 8 | 15 | < 0.1% |
| 9 | 165 | |
| 10 | 152 | |
| 11 | 47 | < 0.1% |
| 12 | 54 | < 0.1% |
| 13 | 21 | < 0.1% |
| 14 | 124 |
| Value | Count | Frequency (%) |
| 999 | 4 | < 0.1% |
| 998 | 23 | < 0.1% |
| 997 | 35 | < 0.1% |
| 996 | 69 | 0.1% |
| 995 | 139 | |
| 994 | 10 | < 0.1% |
| 993 | 165 | |
| 992 | 188 | |
| 991 | 41 | < 0.1% |
| 990 | 89 |
Primary_mortgage_insurance_percent
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 20 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 110716 |
| Missing (%) | 82.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.75980594 |
| Minimum | 6 |
|---|---|
| Maximum | 50 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 18 |
| median | 25 |
| Q3 | 30 |
| 95-th percentile | 30 |
| Maximum | 50 |
| Range | 44 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 7.15112836 |
|---|---|
| Coefficient of variation (CV) | 0.3009758741 |
| Kurtosis | -0.3705245698 |
| Mean | 23.75980594 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.7907650624 |
| Sum | 577886 |
| Variance | 51.13863683 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 25 | 9396 | 7.0% |
| 30 | 7489 | 5.5% |
| 12 | 3806 | 2.8% |
| 17 | 1334 | 1.0% |
| 35 | 953 | 0.7% |
| 6 | 625 | 0.5% |
| 18 | 474 | 0.4% |
| 16 | 210 | 0.2% |
| 20 | 10 | < 0.1% |
| 40 | 7 | < 0.1% |
| Other values (10) | 18 | < 0.1% |
| (Missing) | 110716 |
| Value | Count | Frequency (%) |
| 6 | 625 | 0.5% |
| 10 | 1 | < 0.1% |
| 12 | 3806 | |
| 15 | 4 | < 0.1% |
| 16 | 210 | 0.2% |
| 17 | 1334 | 1.0% |
| 18 | 474 | 0.4% |
| 20 | 10 | < 0.1% |
| 22 | 1 | < 0.1% |
| 23 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 50 | 2 | < 0.1% |
| 40 | 7 | < 0.1% |
| 39 | 1 | < 0.1% |
| 38 | 1 | < 0.1% |
| 35 | 953 | 0.7% |
| 33 | 1 | < 0.1% |
| 30 | 7489 | |
| 28 | 2 | < 0.1% |
| 27 | 4 | < 0.1% |
| 25 | 9396 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| FRM |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FRM |
|---|---|
| 2nd row | FRM |
| 3rd row | FRM |
| 4th row | FRM |
| 5th row | FRM |
Common Values
| Value | Count | Frequency (%) |
| FRM | 135038 |
Length
Pie chart
| Value | Count | Frequency (%) |
| frm | 135038 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Co-borrower_credit_score_at_origination
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 327 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 67672 |
| Missing (%) | 50.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 751.1459045 |
| Minimum | 400 |
|---|---|
| Maximum | 850 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 400 |
|---|---|
| 5-th percentile | 651 |
| Q1 | 721 |
| median | 765 |
| Q3 | 791 |
| 95-th percentile | 810 |
| Maximum | 850 |
| Range | 450 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 50.57622641 |
|---|---|
| Coefficient of variation (CV) | 0.06733209369 |
| Kurtosis | 0.6414205765 |
| Mean | 751.1459045 |
| Median Absolute Deviation (MAD) | 31 |
| Skewness | -1.005586451 |
| Sum | 50601695 |
| Variance | 2557.954678 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 801 | 878 | 0.7% |
| 791 | 870 | 0.6% |
| 790 | 837 | 0.6% |
| 798 | 805 | 0.6% |
| 796 | 798 | 0.6% |
| 793 | 798 | 0.6% |
| 797 | 789 | 0.6% |
| 784 | 778 | 0.6% |
| 802 | 771 | 0.6% |
| 809 | 755 | 0.6% |
| Other values (317) | 59287 | |
| (Missing) | 67672 |
| Value | Count | Frequency (%) |
| 400 | 1 | |
| 467 | 1 | |
| 471 | 1 | |
| 484 | 1 | |
| 486 | 1 | |
| 487 | 1 | |
| 498 | 1 | |
| 501 | 1 | |
| 505 | 2 | |
| 512 | 2 |
| Value | Count | Frequency (%) |
| 850 | 1 | < 0.1% |
| 839 | 2 | < 0.1% |
| 838 | 2 | < 0.1% |
| 835 | 1 | < 0.1% |
| 834 | 2 | < 0.1% |
| 833 | 1 | < 0.1% |
| 832 | 3 | < 0.1% |
| 831 | 1 | < 0.1% |
| 830 | 3 | < 0.1% |
| 829 | 9 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 110716 |
| Missing (%) | 82.0% |
| Memory size | 1.0 MiB |
| 1.0 | |
|---|---|
| 2.0 | 1988 |
| 3.0 | 2 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 22332 | 16.5% |
| 2.0 | 1988 | 1.5% |
| 3.0 | 2 | < 0.1% |
| (Missing) | 110716 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1.0 | 22332 | |
| 2.0 | 1988 | 8.2% |
| 3.0 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 234 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| 2003-07-01 | 2163 |
|---|---|
| 2003-04-01 | 2128 |
| 2003-06-01 | 1985 |
| 2003-05-01 | 1840 |
| 2002-12-01 | 1775 |
| Other values (229) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2007-02-01 |
|---|---|
| 2nd row | 2007-02-01 |
| 3rd row | 2007-02-01 |
| 4th row | 2007-02-01 |
| 5th row | 2007-02-01 |
Common Values
| Value | Count | Frequency (%) |
| 2003-07-01 | 2163 | 1.6% |
| 2003-04-01 | 2128 | 1.6% |
| 2003-06-01 | 1985 | 1.5% |
| 2003-05-01 | 1840 | 1.4% |
| 2002-12-01 | 1775 | 1.3% |
| 2002-10-01 | 1770 | 1.3% |
| 2003-03-01 | 1727 | 1.3% |
| 2002-11-01 | 1637 | 1.2% |
| 2003-08-01 | 1629 | 1.2% |
| 2003-01-01 | 1545 | 1.1% |
| Other values (224) | 116839 |
Length
| Value | Count | Frequency (%) |
| 2003-07-01 | 2163 | 1.6% |
| 2003-04-01 | 2128 | 1.6% |
| 2003-06-01 | 1985 | 1.5% |
| 2003-05-01 | 1840 | 1.4% |
| 2002-12-01 | 1775 | 1.3% |
| 2002-10-01 | 1770 | 1.3% |
| 2003-03-01 | 1727 | 1.3% |
| 2002-11-01 | 1637 | 1.2% |
| 2003-08-01 | 1629 | 1.2% |
| 2003-01-01 | 1545 | 1.1% |
| Other values (224) | 116839 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 235 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| 2003-09-01 | 2144 |
|---|---|
| 2003-06-01 | 2109 |
| 2003-08-01 | 1993 |
| 2003-07-01 | 1851 |
| 2003-05-01 | 1785 |
| Other values (230) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2007-03-01 |
|---|---|
| 2nd row | 2007-04-01 |
| 3rd row | 2007-04-01 |
| 4th row | 2007-04-01 |
| 5th row | 2007-04-01 |
Common Values
| Value | Count | Frequency (%) |
| 2003-09-01 | 2144 | 1.6% |
| 2003-06-01 | 2109 | 1.6% |
| 2003-08-01 | 1993 | 1.5% |
| 2003-07-01 | 1851 | 1.4% |
| 2003-05-01 | 1785 | 1.3% |
| 2002-12-01 | 1740 | 1.3% |
| 2003-02-01 | 1735 | 1.3% |
| 2003-01-01 | 1649 | 1.2% |
| 2003-10-01 | 1595 | 1.2% |
| 2003-03-01 | 1550 | 1.1% |
| Other values (225) | 116887 |
Length
| Value | Count | Frequency (%) |
| 2003-09-01 | 2144 | 1.6% |
| 2003-06-01 | 2109 | 1.6% |
| 2003-08-01 | 1993 | 1.5% |
| 2003-07-01 | 1851 | 1.4% |
| 2003-05-01 | 1785 | 1.3% |
| 2002-12-01 | 1740 | 1.3% |
| 2003-02-01 | 1735 | 1.3% |
| 2003-01-01 | 1649 | 1.2% |
| 2003-10-01 | 1595 | 1.2% |
| 2003-03-01 | 1550 | 1.1% |
| Other values (225) | 116887 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| N | |
|---|---|
| Y | |
| U | 68 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Y |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 120561 | |
| Y | 14409 | 10.7% |
| U | 68 | 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| n | 120561 | |
| y | 14409 | 10.7% |
| u | 68 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 55 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.158662006 |
| Minimum | 3.8 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 3.8 |
|---|---|
| 5-th percentile | 4.1 |
| Q1 | 4.9 |
| median | 5.7 |
| Q3 | 7.5 |
| 95-th percentile | 9.5 |
| Maximum | 10 |
| Range | 6.2 |
| Interquartile range (IQR) | 2.6 |
Descriptive statistics
| Standard deviation | 1.657191534 |
|---|---|
| Coefficient of variation (CV) | 0.2690830464 |
| Kurtosis | -0.4580471642 |
| Mean | 6.158662006 |
| Median Absolute Deviation (MAD) | 0.9 |
| Skewness | 0.7974035707 |
| Sum | 831653.4 |
| Variance | 2.746283782 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5.7 | 9928 | 7.4% |
| 5 | 8106 | 6.0% |
| 6.1 | 6034 | 4.5% |
| 5.9 | 5976 | 4.4% |
| 5.8 | 5757 | 4.3% |
| 4.9 | 5389 | 4.0% |
| 4.7 | 4805 | 3.6% |
| 6 | 4702 | 3.5% |
| 4.4 | 4485 | 3.3% |
| 5.6 | 3884 | 2.9% |
| Other values (45) | 75972 |
| Value | Count | Frequency (%) |
| 3.8 | 634 | 0.5% |
| 3.9 | 1712 | 1.3% |
| 4 | 2930 | |
| 4.1 | 2837 | |
| 4.2 | 2392 | |
| 4.3 | 3223 | |
| 4.4 | 4485 | |
| 4.5 | 2153 | |
| 4.6 | 2821 | |
| 4.7 | 4805 |
| Value | Count | Frequency (%) |
| 10 | 444 | 0.3% |
| 9.9 | 1743 | |
| 9.8 | 1818 | |
| 9.6 | 780 | 0.6% |
| 9.5 | 2914 | |
| 9.4 | 2724 | |
| 9.3 | 723 | 0.5% |
| 9.1 | 1108 | 0.8% |
| 9 | 3408 | |
| 8.8 | 712 | 0.5% |
| Distinct | 223 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 208.1883261 |
| Minimum | 164.7 |
|---|---|
| Maximum | 251.176 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 164.7 |
|---|---|
| 5-th percentile | 176.1 |
| Q1 | 183.1 |
| median | 212.495 |
| Q3 | 231.797 |
| 95-th percentile | 244.028 |
| Maximum | 251.176 |
| Range | 86.476 |
| Interquartile range (IQR) | 48.697 |
Descriptive statistics
| Standard deviation | 24.77699426 |
|---|---|
| Coefficient of variation (CV) | 0.1190124092 |
| Kurtosis | -1.534392425 |
| Mean | 208.1883261 |
| Median Absolute Deviation (MAD) | 25.095 |
| Skewness | 0.03714129161 |
| Sum | 28113335.18 |
| Variance | 613.8994448 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 177.4 | 2905 | 2.2% |
| 183.7 | 2163 | 1.6% |
| 183.2 | 2128 | 1.6% |
| 183.1 | 1985 | 1.5% |
| 177.7 | 1905 | 1.4% |
| 182.9 | 1840 | 1.4% |
| 181.8 | 1775 | 1.3% |
| 181.2 | 1770 | 1.3% |
| 183.9 | 1727 | 1.3% |
| 181.5 | 1637 | 1.2% |
| Other values (213) | 115203 |
| Value | Count | Frequency (%) |
| 164.7 | 20 | < 0.1% |
| 164.8 | 6 | < 0.1% |
| 165.9 | 6 | < 0.1% |
| 166 | 18 | < 0.1% |
| 166.7 | 7 | < 0.1% |
| 167.1 | 12 | < 0.1% |
| 167.8 | 14 | < 0.1% |
| 168.1 | 27 | < 0.1% |
| 168.4 | 135 | |
| 168.8 | 292 |
| Value | Count | Frequency (%) |
| 251.176 | 118 | 0.1% |
| 250.64 | 342 | |
| 249.957 | 431 | |
| 249.475 | 384 | |
| 249.413 | 397 | |
| 248.816 | 459 | |
| 247.847 | 567 | |
| 247.333 | 544 | |
| 246.57 | 594 | |
| 246.445 | 552 |
| Distinct | 78 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| 2003-04-01 | 5953 |
|---|---|
| 2002-10-01 | 5182 |
| 2003-07-01 | 4791 |
| 2003-01-01 | 4754 |
| 2001-10-01 | 3783 |
| Other values (73) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2007-01-01 |
|---|---|
| 2nd row | 2007-01-01 |
| 3rd row | 2007-01-01 |
| 4th row | 2007-01-01 |
| 5th row | 2007-01-01 |
Common Values
| Value | Count | Frequency (%) |
| 2003-04-01 | 5953 | 4.4% |
| 2002-10-01 | 5182 | 3.8% |
| 2003-07-01 | 4791 | 3.5% |
| 2003-01-01 | 4754 | 3.5% |
| 2001-10-01 | 3783 | 2.8% |
| 2002-07-01 | 3299 | 2.4% |
| 2001-04-01 | 2922 | 2.2% |
| 2009-04-01 | 2666 | 2.0% |
| 2002-01-01 | 2577 | 1.9% |
| 2012-10-01 | 2572 | 1.9% |
| Other values (68) | 96539 |
Length
| Value | Count | Frequency (%) |
| 2003-04-01 | 5953 | 4.4% |
| 2002-10-01 | 5182 | 3.8% |
| 2003-07-01 | 4791 | 3.5% |
| 2003-01-01 | 4754 | 3.5% |
| 2001-10-01 | 3783 | 2.8% |
| 2002-07-01 | 3299 | 2.4% |
| 2001-04-01 | 2922 | 2.2% |
| 2009-04-01 | 2666 | 2.0% |
| 2002-01-01 | 2577 | 1.9% |
| 2012-10-01 | 2572 | 1.9% |
| Other values (68) | 96539 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 43 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.083868244 |
| Minimum | -8.4 |
|---|---|
| Maximum | 7.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 17017 |
| Negative (%) | 12.6% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | -8.4 |
|---|---|
| 5-th percentile | -1.7 |
| Q1 | 0.9 |
| median | 2.2 |
| Q3 | 3.5 |
| 95-th percentile | 5.5 |
| Maximum | 7.5 |
| Range | 15.9 |
| Interquartile range (IQR) | 2.6 |
Descriptive statistics
| Standard deviation | 2.31057909 |
|---|---|
| Coefficient of variation (CV) | 1.108793273 |
| Kurtosis | 3.309587534 |
| Mean | 2.083868244 |
| Median Absolute Deviation (MAD) | 1.3 |
| Skewness | -0.8653541067 |
| Sum | 281401.4 |
| Variance | 5.338775732 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.5 | 12026 | 8.9% |
| 2.2 | 11496 | 8.5% |
| 0.5 | 8479 | 6.3% |
| 3.2 | 8333 | 6.2% |
| 0.6 | 6134 | 4.5% |
| 2 | 5702 | 4.2% |
| 7 | 5245 | 3.9% |
| 2.4 | 4933 | 3.7% |
| 2.3 | 3969 | 2.9% |
| 4.7 | 3902 | 2.9% |
| Other values (33) | 64819 |
| Value | Count | Frequency (%) |
| -8.4 | 1073 | 0.8% |
| -4.4 | 2555 | |
| -2.3 | 1452 | |
| -2.1 | 1036 | 0.8% |
| -1.7 | 2388 | |
| -1.1 | 3157 | |
| -1 | 1218 | 0.9% |
| -0.6 | 2666 | |
| -0.1 | 1472 | |
| 0.1 | 1404 |
| Value | Count | Frequency (%) |
| 7.5 | 1072 | 0.8% |
| 7 | 5245 | |
| 5.5 | 1211 | 0.9% |
| 5.4 | 839 | 0.6% |
| 5.3 | 33 | < 0.1% |
| 5 | 1351 | 1.0% |
| 4.7 | 3902 | |
| 4.5 | 2402 | |
| 4.1 | 1245 | 0.9% |
| 3.8 | 1224 | 0.9% |
| Distinct | 233 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.478040072 |
| Minimum | 1.504 |
|---|---|
| Maximum | 6.661 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 1.504 |
|---|---|
| 5-th percentile | 1.719 |
| Q1 | 2.324545455 |
| median | 3.675 |
| Q3 | 4.347619048 |
| 95-th percentile | 5.284 |
| Maximum | 6.661 |
| Range | 5.157 |
| Interquartile range (IQR) | 2.023073593 |
Descriptive statistics
| Standard deviation | 1.207100069 |
|---|---|
| Coefficient of variation (CV) | 0.3470633012 |
| Kurtosis | -0.9648517968 |
| Mean | 3.478040072 |
| Median Absolute Deviation (MAD) | 1.0405 |
| Skewness | 0.1287623962 |
| Sum | 469667.5753 |
| Variance | 1.457090577 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.975454545 | 2163 | 1.6% |
| 3.958571429 | 2128 | 1.6% |
| 3.334285714 | 1985 | 1.5% |
| 3.569047619 | 1840 | 1.4% |
| 4.032380952 | 1775 | 1.3% |
| 3.940909091 | 1770 | 1.3% |
| 3.807142857 | 1727 | 1.3% |
| 4.048421053 | 1637 | 1.2% |
| 4.445238095 | 1629 | 1.2% |
| 5.0875 | 1582 | 1.2% |
| Other values (223) | 116802 |
| Value | Count | Frequency (%) |
| 1.504 | 628 | |
| 1.526666667 | 788 | |
| 1.556521739 | 880 | |
| 1.622380952 | 771 | |
| 1.63047619 | 846 | |
| 1.644090909 | 662 | |
| 1.654 | 867 | |
| 1.67826087 | 891 | |
| 1.719 | 825 | |
| 1.723157895 | 767 |
| Value | Count | Frequency (%) |
| 6.661 | 231 | |
| 6.5195 | 268 | |
| 6.440454545 | 370 | |
| 6.275454545 | 292 | |
| 6.256521739 | 332 | |
| 6.112 | 27 | < 0.1% |
| 6.097272727 | 410 | |
| 6.054 | 349 | |
| 6.034 | 135 | 0.1% |
| 5.990526316 | 292 |
| Distinct | 233 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56.27779559 |
| Minimum | 11.99 |
|---|---|
| Maximum | 133.9271429 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 11.99 |
|---|---|
| 5-th percentile | 25.51 |
| Q1 | 30.71 |
| median | 48.74863636 |
| Q3 | 81.89952381 |
| 95-th percentile | 103.2842857 |
| Maximum | 133.9271429 |
| Range | 121.9371429 |
| Interquartile range (IQR) | 51.18952381 |
Descriptive statistics
| Standard deviation | 27.84104655 |
|---|---|
| Coefficient of variation (CV) | 0.494707482 |
| Kurtosis | -0.9150173174 |
| Mean | 56.27779559 |
| Median Absolute Deviation (MAD) | 20.34863636 |
| Skewness | 0.5551308717 |
| Sum | 7599640.961 |
| Variance | 775.123873 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 30.73434783 | 2163 | 1.6% |
| 28.32818182 | 2128 | 1.6% |
| 30.71 | 1985 | 1.5% |
| 28.20181818 | 1840 | 1.4% |
| 29.44 | 1775 | 1.3% |
| 28.85 | 1770 | 1.3% |
| 33.31571429 | 1727 | 1.3% |
| 26.56 | 1637 | 1.2% |
| 31.58380952 | 1629 | 1.2% |
| 32.91521739 | 1545 | 1.1% |
| Other values (223) | 116839 |
| Value | Count | Frequency (%) |
| 11.99 | 10 | < 0.1% |
| 12.34 | 10 | < 0.1% |
| 14.36 | 6 | < 0.1% |
| 17.23 | 6 | < 0.1% |
| 17.72 | 12 | < 0.1% |
| 17.75 | 6 | < 0.1% |
| 19.31 | 1281 | |
| 19.59 | 1318 | |
| 19.69 | 964 | |
| 19.89 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 133.9271429 | 453 | |
| 133.8956522 | 358 | |
| 125.6554545 | 473 | |
| 116.6404762 | 361 | |
| 112.6186364 | 599 | |
| 110.0428571 | 308 | |
| 106.5463636 | 625 | |
| 106.3138095 | 460 | |
| 106.1504545 | 731 | |
| 105.3447619 | 476 |
| Distinct | 234 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 963119.3409 |
| Minimum | 708818 |
|---|---|
| Maximum | 1335425 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 708818 |
|---|---|
| 5-th percentile | 798248 |
| Q1 | 846777 |
| median | 891264 |
| Q3 | 1101187 |
| 95-th percentile | 1260760 |
| Maximum | 1335425 |
| Range | 626607 |
| Interquartile range (IQR) | 254410 |
Descriptive statistics
| Standard deviation | 153846.4496 |
|---|---|
| Coefficient of variation (CV) | 0.1597376805 |
| Kurtosis | -0.7613237989 |
| Mean | 963119.3409 |
| Median Absolute Deviation (MAD) | 73530 |
| Skewness | 0.7804033785 |
| Sum | 1.300577096 × 1011 |
| Variance | 2.366873004 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 891264 | 2163 | 1.6% |
| 859459 | 2128 | 1.6% |
| 880865 | 1985 | 1.5% |
| 866814 | 1840 | 1.4% |
| 855921 | 1775 | 1.3% |
| 839690 | 1770 | 1.3% |
| 851132 | 1727 | 1.3% |
| 844697 | 1637 | 1.2% |
| 901839 | 1629 | 1.2% |
| 863855 | 1545 | 1.1% |
| Other values (224) | 116839 |
| Value | Count | Frequency (%) |
| 708818 | 10 | < 0.1% |
| 726308 | 10 | < 0.1% |
| 727358 | 6 | < 0.1% |
| 728788 | 6 | < 0.1% |
| 737226 | 6 | < 0.1% |
| 739167 | 12 | < 0.1% |
| 741524 | 12 | < 0.1% |
| 745815 | 7 | < 0.1% |
| 751402 | 14 | < 0.1% |
| 755410 | 379 |
| Value | Count | Frequency (%) |
| 1335425 | 384 | |
| 1333468 | 342 | |
| 1322364 | 431 | |
| 1317790 | 118 | 0.1% |
| 1312855 | 397 | |
| 1297449 | 459 | |
| 1295930 | 567 | |
| 1290213 | 544 | |
| 1269670 | 387 | |
| 1268793 | 512 |
| Distinct | 234 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.180771125 |
| Minimum | 0.8525380952 |
|---|---|
| Maximum | 1.575863636 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0.8525380952 |
|---|---|
| 5-th percentile | 0.8859954545 |
| Q1 | 1.072657895 |
| median | 1.191335 |
| Q3 | 1.316019048 |
| 95-th percentile | 1.440286364 |
| Maximum | 1.575863636 |
| Range | 0.7233255411 |
| Interquartile range (IQR) | 0.2433611529 |
Descriptive statistics
| Standard deviation | 0.1727537297 |
|---|---|
| Coefficient of variation (CV) | 0.1463058556 |
| Kurtosis | -0.7560880363 |
| Mean | 1.180771125 |
| Median Absolute Deviation (MAD) | 0.1222306522 |
| Skewness | -0.15430538 |
| Sum | 159448.9711 |
| Variance | 0.02984385113 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.136504545 | 2163 | 1.6% |
| 1.086236364 | 2128 | 1.6% |
| 1.167428571 | 1985 | 1.5% |
| 1.155557143 | 1840 | 1.4% |
| 1.019404762 | 1775 | 1.3% |
| 0.98115 | 1770 | 1.3% |
| 1.079742857 | 1727 | 1.3% |
| 1.001289474 | 1637 | 1.2% |
| 1.115519048 | 1629 | 1.2% |
| 1.062247619 | 1545 | 1.1% |
| Other values (224) | 116839 |
| Value | Count | Frequency (%) |
| 0.8525380952 | 442 | |
| 0.8529571429 | 941 | |
| 0.855152381 | 437 | |
| 0.8614857143 | 745 | |
| 0.869475 | 390 | 0.3% |
| 0.8706947368 | 779 | |
| 0.8753136364 | 1040 | |
| 0.8766380952 | 834 | |
| 0.8831619048 | 964 | |
| 0.8859954545 | 687 |
| Value | Count | Frequency (%) |
| 1.575863636 | 358 | |
| 1.575363636 | 599 | |
| 1.556171429 | 453 | |
| 1.555414286 | 473 | |
| 1.552019048 | 476 | |
| 1.495538095 | 361 | |
| 1.490752632 | 428 | |
| 1.482114286 | 444 | |
| 1.475945 | 572 | |
| 1.472814286 | 404 |
| Distinct | 231 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -42336.57545 |
| Minimum | -67823 |
|---|---|
| Maximum | -15946 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 135038 |
| Negative (%) | 100.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | -67823 |
|---|---|
| 5-th percentile | -61797 |
| Q1 | -45943 |
| median | -41360 |
| Q3 | -36519 |
| 95-th percentile | -28800 |
| Maximum | -15946 |
| Range | 51877 |
| Interquartile range (IQR) | 9424 |
Descriptive statistics
| Standard deviation | 9404.518716 |
|---|---|
| Coefficient of variation (CV) | -0.2221369729 |
| Kurtosis | 0.1517299755 |
| Mean | -42336.57545 |
| Median Absolute Deviation (MAD) | 4841 |
| Skewness | -0.6459291409 |
| Sum | -5717046476 |
| Variance | 88444972.27 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -41363 | 2163 | 1.6% |
| -41987 | 2128 | 1.6% |
| -39621 | 1985 | 1.5% |
| -40779 | 1840 | 1.4% |
| -43294 | 1775 | 1.3% |
| -35171 | 1770 | 1.3% |
| -43355 | 1727 | 1.3% |
| -39624 | 1637 | 1.2% |
| -39802 | 1629 | 1.2% |
| -37842 | 1608 | 1.2% |
| Other values (221) | 116776 |
| Value | Count | Frequency (%) |
| -67823 | 332 | |
| -67140 | 441 | |
| -66842 | 358 | |
| -66680 | 231 | |
| -66525 | 301 | |
| -64936 | 319 | |
| -64923 | 456 | |
| -64844 | 337 | |
| -64366 | 286 | |
| -64348 | 572 |
| Value | Count | Frequency (%) |
| -15946 | 10 | < 0.1% |
| -17900 | 6 | < 0.1% |
| -18254 | 6 | < 0.1% |
| -18786 | 10 | < 0.1% |
| -20229 | 6 | < 0.1% |
| -22899 | 14 | |
| -22977 | 12 | |
| -23115 | 12 | |
| -23421 | 7 | < 0.1% |
| -23531 | 27 |
GOLDAMGBD228NLBM
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 234 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 845.9498032 |
| Minimum | 256.1977273 |
|---|---|
| Maximum | 1780.647727 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 256.1977273 |
|---|---|
| 5-th percentile | 272.0571429 |
| Q1 | 350.7652174 |
| median | 857.7261905 |
| Q3 | 1273.579545 |
| 95-th percentile | 1671.886364 |
| Maximum | 1780.647727 |
| Range | 1524.45 |
| Interquartile range (IQR) | 922.8143281 |
Descriptive statistics
| Standard deviation | 498.1153598 |
|---|---|
| Coefficient of variation (CV) | 0.5888237788 |
| Kurtosis | -1.438866177 |
| Mean | 845.9498032 |
| Median Absolute Deviation (MAD) | 479.702381 |
| Skewness | 0.2444715983 |
| Sum | 114235369.5 |
| Variance | 248118.9117 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 350.7652174 | 2163 | 1.6% |
| 328.2075 | 2128 | 1.6% |
| 356.9119048 | 1985 | 1.5% |
| 355.405 | 1840 | 1.4% |
| 333.3 | 1775 | 1.3% |
| 316.7478261 | 1770 | 1.3% |
| 341.5642857 | 1727 | 1.3% |
| 319.2547619 | 1637 | 1.2% |
| 358.9925 | 1629 | 1.2% |
| 356.8636364 | 1545 | 1.1% |
| Other values (224) | 116839 |
| Value | Count | Frequency (%) |
| 256.1977273 | 7 | < 0.1% |
| 256.9357143 | 12 | < 0.1% |
| 260.75 | 941 | |
| 261.4022727 | 12 | < 0.1% |
| 262.0175 | 759 | |
| 263.2727273 | 990 | |
| 264.4704545 | 14 | < 0.1% |
| 265.9340909 | 499 | |
| 265.9886364 | 437 | |
| 267.7068182 | 745 |
| Value | Count | Frequency (%) |
| 1780.647727 | 664 | |
| 1759.5 | 454 | |
| 1746.347826 | 880 | |
| 1743.095238 | 669 | |
| 1741.925 | 767 | |
| 1735.977273 | 688 | |
| 1724.352273 | 867 | |
| 1687.342105 | 825 | |
| 1675.056818 | 731 | |
| 1671.886364 | 716 |
| Distinct | 234 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 148.6342832 |
| Minimum | 93.236 |
|---|---|
| Maximum | 202.411 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 93.236 |
|---|---|
| 5-th percentile | 111.111 |
| Q1 | 130.151 |
| median | 145.632 |
| Q3 | 169.868 |
| 95-th percentile | 188.951 |
| Maximum | 202.411 |
| Range | 109.175 |
| Interquartile range (IQR) | 39.717 |
Descriptive statistics
| Standard deviation | 24.71270765 |
|---|---|
| Coefficient of variation (CV) | 0.1662651922 |
| Kurtosis | -0.887312779 |
| Mean | 148.6342832 |
| Median Absolute Deviation (MAD) | 18.965 |
| Skewness | 0.1780414115 |
| Sum | 20071276.33 |
| Variance | 610.7179195 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 133.777 | 2163 | 1.6% |
| 130.886 | 2128 | 1.6% |
| 132.651 | 1985 | 1.5% |
| 131.737 | 1840 | 1.4% |
| 127.619 | 1775 | 1.3% |
| 125.733 | 1770 | 1.3% |
| 130.151 | 1727 | 1.3% |
| 126.667 | 1637 | 1.2% |
| 134.969 | 1629 | 1.2% |
| 128.462 | 1545 | 1.1% |
| Other values (224) | 116839 |
| Value | Count | Frequency (%) |
| 93.236 | 10 | < 0.1% |
| 93.698 | 10 | < 0.1% |
| 94.244 | 6 | < 0.1% |
| 94.813 | 6 | < 0.1% |
| 95.372 | 6 | < 0.1% |
| 96.003 | 12 | |
| 96.619 | 7 | < 0.1% |
| 97.246 | 12 | |
| 97.892 | 14 | |
| 98.554 | 27 |
| Value | Count | Frequency (%) |
| 202.411 | 118 | 0.1% |
| 201.758 | 342 | |
| 201.091 | 431 | |
| 200.347 | 397 | |
| 199.461 | 384 | |
| 198.472 | 459 | |
| 197.201 | 567 | |
| 196.012 | 544 | |
| 194.88 | 594 | |
| 193.794 | 552 |
| Distinct | 76 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 231137.665 |
| Minimum | 157400 |
|---|---|
| Maximum | 337900 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 157400 |
|---|---|
| 5-th percentile | 171100 |
| Q1 | 190100 |
| median | 224100 |
| Q3 | 258400 |
| 95-th percentile | 315600 |
| Maximum | 337900 |
| Range | 180500 |
| Interquartile range (IQR) | 68300 |
Descriptive statistics
| Standard deviation | 46186.08414 |
|---|---|
| Coefficient of variation (CV) | 0.1998206746 |
| Kurtosis | -0.7330918917 |
| Mean | 231137.665 |
| Median Absolute Deviation (MAD) | 34000 |
| Skewness | 0.5377179553 |
| Sum | 3.1212368 × 1010 |
| Variance | 2133154368 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 191800 | 5953 | 4.4% |
| 190100 | 5182 | 3.8% |
| 191900 | 4791 | 3.5% |
| 186000 | 4754 | 3.5% |
| 171100 | 3783 | 2.8% |
| 178100 | 3299 | 2.4% |
| 238400 | 3286 | 2.4% |
| 179000 | 2922 | 2.2% |
| 220900 | 2666 | 2.0% |
| 188700 | 2577 | 1.9% |
| Other values (66) | 95825 |
| Value | Count | Frequency (%) |
| 157400 | 26 | < 0.1% |
| 158700 | 24 | < 0.1% |
| 159100 | 33 | < 0.1% |
| 163200 | 1072 | 0.8% |
| 165300 | 1285 | 1.0% |
| 168800 | 1142 | 0.8% |
| 169800 | 2248 | |
| 171100 | 3783 | |
| 172500 | 2388 | |
| 172900 | 1322 | 1.0% |
| Value | Count | Frequency (%) |
| 337900 | 1705 | |
| 331800 | 1240 | |
| 320500 | 1723 | |
| 318200 | 1685 | |
| 315600 | 891 | 0.7% |
| 313100 | 1392 | |
| 310900 | 2100 | |
| 306000 | 1948 | |
| 303800 | 2354 | |
| 302500 | 1404 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Loan_Identifier | Origination_Channel | Seller_Name | Original_Interest_Rate | Original_UPB | Original_Loan_Term | Original_LTV_(OLTV) | Original_Combined_LTV_(CLTV) | Number_of_Borrowers | Original_Debt_to_Income_Ratio | Borrower_Credit_Score_at_Origination | Loan_purpose | Property_type | Number_of_units | Occupancy_type | Property_state | Zip_code_short | Primary_mortgage_insurance_percent | Product_type | Co-borrower_credit_score_at_origination | Mortgage_Insurance_type | Origination_Date | First_payment_date | First_time_home_buyer_indicator | UNRATE | CPIAUCSL | Qdate | rGDP | TCMR | POILWTIUSDM | TTLCONS | DEXUSEU | BOPGSTB | GOLDAMGBD228NLBM | CSUSHPISA | MSPUS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 9.733730e+11 | B | OTHER | 6.875 | 32000.0 | 360.0 | 90.0 | 90.0 | 1.0 | 22.0 | 669.0 | P | SF | 1.0 | P | AL | 358.0 | 35.0 | FRM | NaN | 1.0 | 2007-02-01 | 2007-03-01 | Y | 4.5 | 204.226 | 2007-01-01 | 0.9 | 4.722632 | 59.257 | 1138752.0 | 1.308021 | -58478.0 | 665.1025 | 184.601 | 257400.0 |
| 1 | 9.276200e+11 | B | PNC BANK, N.A. | 5.875 | 200000.0 | 360.0 | 80.0 | 80.0 | 2.0 | 26.0 | 693.0 | P | SF | 1.0 | P | AL | 350.0 | NaN | FRM | 675.0 | NaN | 2007-02-01 | 2007-04-01 | N | 4.5 | 204.226 | 2007-01-01 | 0.9 | 4.722632 | 59.257 | 1138752.0 | 1.308021 | -58478.0 | 665.1025 | 184.601 | 257400.0 |
| 2 | 7.176670e+11 | B | OTHER | 6.250 | 122000.0 | 180.0 | 80.0 | 80.0 | 2.0 | 31.0 | 741.0 | C | SF | 1.0 | P | AL | 359.0 | NaN | FRM | 759.0 | NaN | 2007-02-01 | 2007-04-01 | N | 4.5 | 204.226 | 2007-01-01 | 0.9 | 4.722632 | 59.257 | 1138752.0 | 1.308021 | -58478.0 | 665.1025 | 184.601 | 257400.0 |
| 3 | 9.889510e+11 | C | AMTRUST BANK | 6.000 | 67000.0 | 180.0 | 77.0 | 77.0 | 2.0 | 17.0 | 804.0 | C | SF | 1.0 | I | AL | 356.0 | NaN | FRM | 805.0 | NaN | 2007-02-01 | 2007-04-01 | N | 4.5 | 204.226 | 2007-01-01 | 0.9 | 4.722632 | 59.257 | 1138752.0 | 1.308021 | -58478.0 | 665.1025 | 184.601 | 257400.0 |
| 4 | 1.908850e+11 | R | OTHER | 5.875 | 50000.0 | 180.0 | 41.0 | 41.0 | 2.0 | 10.0 | 658.0 | C | SF | 1.0 | P | AR | 728.0 | NaN | FRM | 697.0 | NaN | 2007-02-01 | 2007-04-01 | N | 4.5 | 204.226 | 2007-01-01 | 0.9 | 4.722632 | 59.257 | 1138752.0 | 1.308021 | -58478.0 | 665.1025 | 184.601 | 257400.0 |
| 5 | 7.533710e+11 | R | OTHER | 6.375 | 160000.0 | 360.0 | 95.0 | 95.0 | 3.0 | 28.0 | 665.0 | P | SF | 1.0 | S | AR | 719.0 | 30.0 | FRM | NaN | 1.0 | 2007-02-01 | 2007-04-01 | N | 4.5 | 204.226 | 2007-01-01 | 0.9 | 4.722632 | 59.257 | 1138752.0 | 1.308021 | -58478.0 | 665.1025 | 184.601 | 257400.0 |
| 6 | 7.038110e+11 | C | CITIMORTGAGE, INC. | 5.875 | 176000.0 | 180.0 | 80.0 | 90.0 | 2.0 | 22.0 | 773.0 | C | SF | 1.0 | P | AR | 721.0 | NaN | FRM | NaN | NaN | 2007-02-01 | 2007-04-01 | N | 4.5 | 204.226 | 2007-01-01 | 0.9 | 4.722632 | 59.257 | 1138752.0 | 1.308021 | -58478.0 | 665.1025 | 184.601 | 257400.0 |
| 7 | 7.947140e+11 | B | FIRST TENNESSEE BANK NATIONAL ASSOCIATION | 7.000 | 294000.0 | 360.0 | 80.0 | 80.0 | 2.0 | 28.0 | 783.0 | P | PU | 1.0 | I | AZ | 857.0 | NaN | FRM | 782.0 | NaN | 2007-02-01 | 2007-04-01 | N | 4.5 | 204.226 | 2007-01-01 | 0.9 | 4.722632 | 59.257 | 1138752.0 | 1.308021 | -58478.0 | 665.1025 | 184.601 | 257400.0 |
| 8 | 5.789070e+11 | C | BANK OF AMERICA, N.A. | 6.375 | 128000.0 | 360.0 | 66.0 | 66.0 | 1.0 | 41.0 | 668.0 | C | SF | 1.0 | P | AZ | 850.0 | NaN | FRM | NaN | NaN | 2007-02-01 | 2007-04-01 | N | 4.5 | 204.226 | 2007-01-01 | 0.9 | 4.722632 | 59.257 | 1138752.0 | 1.308021 | -58478.0 | 665.1025 | 184.601 | 257400.0 |
| 9 | 8.264440e+11 | C | BANK OF AMERICA, N.A. | 6.375 | 115000.0 | 360.0 | 35.0 | 35.0 | 2.0 | 20.0 | 792.0 | C | SF | 1.0 | P | AZ | 856.0 | NaN | FRM | 704.0 | NaN | 2007-02-01 | 2007-04-01 | N | 4.5 | 204.226 | 2007-01-01 | 0.9 | 4.722632 | 59.257 | 1138752.0 | 1.308021 | -58478.0 | 665.1025 | 184.601 | 257400.0 |
Last rows
| Loan_Identifier | Origination_Channel | Seller_Name | Original_Interest_Rate | Original_UPB | Original_Loan_Term | Original_LTV_(OLTV) | Original_Combined_LTV_(CLTV) | Number_of_Borrowers | Original_Debt_to_Income_Ratio | Borrower_Credit_Score_at_Origination | Loan_purpose | Property_type | Number_of_units | Occupancy_type | Property_state | Zip_code_short | Primary_mortgage_insurance_percent | Product_type | Co-borrower_credit_score_at_origination | Mortgage_Insurance_type | Origination_Date | First_payment_date | First_time_home_buyer_indicator | UNRATE | CPIAUCSL | Qdate | rGDP | TCMR | POILWTIUSDM | TTLCONS | DEXUSEU | BOPGSTB | GOLDAMGBD228NLBM | CSUSHPISA | MSPUS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135028 | 3.093700e+11 | R | LOANDEPOT.COM, LLC | 4.875 | 240000.0 | 360.0 | 60.0 | 60.0 | 1.0 | 47.0 | 711.0 | C | PU | 1.0 | P | VA | 201.0 | NaN | FRM | NaN | NaN | 2018-06-01 | 2018-08-01 | N | 4.0 | 251.176 | 2018-04-01 | 3.5 | 2.89 | 67.522857 | 1317790.0 | 1.1679 | -47431.0 | 1299.15 | 202.411 | 315600.0 |
| 135029 | 7.464840e+11 | R | OTHER | 4.625 | 415000.0 | 360.0 | 58.0 | 58.0 | 2.0 | 27.0 | 799.0 | P | SF | 1.0 | P | VA | 222.0 | NaN | FRM | 786.0 | NaN | 2018-06-01 | 2018-08-01 | Y | 4.0 | 251.176 | 2018-04-01 | 3.5 | 2.89 | 67.522857 | 1317790.0 | 1.1679 | -47431.0 | 1299.15 | 202.411 | 315600.0 |
| 135030 | 9.961980e+11 | R | OTHER | 4.625 | 118000.0 | 180.0 | 67.0 | 67.0 | 1.0 | 28.0 | 802.0 | P | CO | 1.0 | S | VT | 57.0 | NaN | FRM | NaN | NaN | 2018-06-01 | 2018-08-01 | N | 4.0 | 251.176 | 2018-04-01 | 3.5 | 2.89 | 67.522857 | 1317790.0 | 1.1679 | -47431.0 | 1299.15 | 202.411 | 315600.0 |
| 135031 | 1.149900e+11 | R | OTHER | 4.875 | 344000.0 | 360.0 | 97.0 | 97.0 | 2.0 | 42.0 | 711.0 | P | CO | 1.0 | P | WA | 982.0 | 25.0 | FRM | 729.0 | 1.0 | 2018-06-01 | 2018-08-01 | Y | 4.0 | 251.176 | 2018-04-01 | 3.5 | 2.89 | 67.522857 | 1317790.0 | 1.1679 | -47431.0 | 1299.15 | 202.411 | 315600.0 |
| 135032 | 9.415520e+11 | R | FAIRWAY INDEPENDENT MORTGAGE CORPORATION | 4.990 | 364000.0 | 360.0 | 80.0 | 80.0 | 1.0 | 45.0 | 785.0 | P | SF | 1.0 | P | WA | 985.0 | NaN | FRM | NaN | NaN | 2018-06-01 | 2018-08-01 | N | 4.0 | 251.176 | 2018-04-01 | 3.5 | 2.89 | 67.522857 | 1317790.0 | 1.1679 | -47431.0 | 1299.15 | 202.411 | 315600.0 |
| 135033 | 9.204900e+11 | R | OTHER | 4.625 | 200000.0 | 240.0 | 50.0 | 50.0 | 1.0 | 45.0 | 717.0 | R | PU | 1.0 | P | WA | 986.0 | NaN | FRM | NaN | NaN | 2018-06-01 | 2018-08-01 | N | 4.0 | 251.176 | 2018-04-01 | 3.5 | 2.89 | 67.522857 | 1317790.0 | 1.1679 | -47431.0 | 1299.15 | 202.411 | 315600.0 |
| 135034 | 9.666890e+11 | R | OTHER | 4.625 | 94000.0 | 360.0 | 47.0 | 47.0 | 1.0 | 39.0 | 677.0 | R | SF | 1.0 | P | WI | 531.0 | NaN | FRM | NaN | NaN | 2018-06-01 | 2018-08-01 | N | 4.0 | 251.176 | 2018-04-01 | 3.5 | 2.89 | 67.522857 | 1317790.0 | 1.1679 | -47431.0 | 1299.15 | 202.411 | 315600.0 |
| 135035 | 6.616280e+11 | R | OTHER | 4.625 | 239000.0 | 360.0 | 74.0 | 74.0 | 2.0 | 20.0 | 788.0 | R | SF | 1.0 | S | WI | 545.0 | NaN | FRM | 739.0 | NaN | 2018-06-01 | 2018-08-01 | N | 4.0 | 251.176 | 2018-04-01 | 3.5 | 2.89 | 67.522857 | 1317790.0 | 1.1679 | -47431.0 | 1299.15 | 202.411 | 315600.0 |
| 135036 | 5.102850e+11 | R | OTHER | 5.000 | 93000.0 | 360.0 | 44.0 | 44.0 | 1.0 | 19.0 | 621.0 | C | SF | 1.0 | P | WI | 537.0 | NaN | FRM | NaN | NaN | 2018-06-01 | 2018-08-01 | N | 4.0 | 251.176 | 2018-04-01 | 3.5 | 2.89 | 67.522857 | 1317790.0 | 1.1679 | -47431.0 | 1299.15 | 202.411 | 315600.0 |
| 135037 | 4.330130e+11 | R | OTHER | 5.125 | 140000.0 | 360.0 | 94.0 | 94.0 | 1.0 | 36.0 | 660.0 | P | SF | 1.0 | P | WI | 549.0 | 30.0 | FRM | NaN | 1.0 | 2018-06-01 | 2018-08-01 | Y | 4.0 | 251.176 | 2018-04-01 | 3.5 | 2.89 | 67.522857 | 1317790.0 | 1.1679 | -47431.0 | 1299.15 | 202.411 | 315600.0 |